USE [wdms]
GO

-- =============================================
-- Author     :		Lohith Ram D V
-- Create date:         07/mar/2011
-- Description:	Adds a row indicating that a specific document has been modified.
-- =============================================

create procedure sp_AddDateTimeofDocumentModification (
	@par_docid int)
AS
BEGIN
    INSERT INTO [Doc_Modification] ([doc_id], [mod_datetime])
    VALUES (@par_docid, CURRENT_TIMESTAMP)
END
